-
Re: How to get dashboard to pull from cells in input sheet once a new date is entered?
@MarvinTangen You can hide the Max Date column once it's created so you don't have to look at it when you look at your input sheet.1 · -
Re: SumIf Date Range
@brbradle Your formula is trying to find a cell with a date that's less than Sept 1st 2021 and greater than August 31st 2022. That's not possible. I think you just need to reverse the greater than an…1 · -
Re: Want a copy of automated email "Send to contacts in a cell"
@Sancta Watley Set up your trigger in the Automation and then set up 2 actions like this: For the bottom one, you'll select yourself as the specific person. You can edit the message to include the Co…1 · -
Re: How to enable color settings on Gantt chart view
@toni.toni601 You have to right-click on a task's bar. You cannot do it on a parent row's bar. Yes: No:1 · -
Re: How to add a prefix to a project ID
@Ddabbs Create an Auto Number column with your preferred number format. Then create a column which builds your Project ID based on another column which helps determine the abc or def prefix and then …1 ·